from utils.database import db

class Transaction(db.Model):
    __tablename__ = 'tradeinfo'
    
    id = db.Column(db.Integer, primary_key=True)  # 添加主键
    trade_date = db.Column(db.DateTime)
    trade_type = db.Column(db.String(6))
    card_id = db.Column(db.String(19))
    trade_money = db.Column(db.Numeric(18, 2))
    remark = db.Column(db.Text)